| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Elana Vaho
   |
Posted - 2008.09.21 16:44:00 -
[1]
Tried the new SVN version and getting an error on the Track Outpost page saying:
Unknown column 'outpost_id' in 'where clause'SELECT pos3_tower_info.* FROM pos3_tower_info WHERE outpost_id = '2' ORDER BY outpost_id
I suspect there is something missing in the database and this will be fixed in a newer version/beta?
|
Elana Vaho
|
Posted - 2008.09.21 17:41:00 -
[2]
 Originally by: Johnathan Roark
Originally by: Elana Vaho
Tried the new SVN version and getting an error on the Track Outpost page saying:
Unknown column 'outpost_id' in 'where clause'SELECT pos3_tower_info.* FROM pos3_tower_info WHERE outpost_id = '2' ORDER BY outpost_id
I suspect there is something missing in the database and this will be fixed in a newer version/beta?
Yea, if your upgrading from a previous version and not installing a fresh copy. you need to run the following sql statements, first one being more important. Replace %prefix% with your table prefix.
[code]ALTER TABLE `%prefix%tower_info` CHANGE `outpost_name` `outpost_id` BIGINT( 20 ) NOT NULL DEFAULT '0';
DROP TABLE `%prefix%outpost_update_log`;
Ahh, that did the trick. Thank you :)
|
Elana Vaho
|
Posted - 2008.10.20 12:39:00 -
[3]
Sorry, but your link seems to go to the old beta 3 version still. Found beta 4 when I searched for it myself though
Postracker3 beta4
|
Elana Vaho
|
Posted - 2009.01.31 11:32:00 -
[4]
Edited by: Elana Vaho on 31/01/2009 11:32:35
Edited by: Elana Vaho on 31/01/2009 11:32:26
Edited by: Elana Vaho on 31/01/2009 11:32:11
This might have been disscused before or if there is a readme somewhere I would really much like to read it :) I was wondering about moon mining, silos and reactions. I'm trying to understand outputs, inputs and how to setup reactions so it works as I want it. Lets try with an example:
Moon harvester (Chromium)=====\
.......................................................==> Simple Reactor (Hexite) ==> Silo (Hexite)
Moon harvester (Platinum)=====/
How would I do to set it up like that?
|
Elana Vaho
|
Posted - 2009.02.04 22:12:00 -
[5]
Originally by: R4v3n Two
Any plans to add Unrefined Reactions to it?
Good job btw! Keep up the nice work!
This is something I'm wondering as well. Any plans for it? Don't know if there is much work for it involved. Would be very much appreciated :)
|
Elana Vaho
|
Posted - 2009.03.06 11:13:00 -
[6]
There is something buggy with the Outpost Track page. I have 4 towers linked to an outpost. When I view the outpost I get good numbers except for liquid ozone and heavy water. It says that I need 12.070.000 LO and 5275 HW per hour, when it should be 398 and 130. I have no idea why I get these kind of numbers.
|
Elana Vaho
|
Posted - 2009.03.08 11:55:00 -
[7]
Exactly why do you want to use the Outpost Track page? As it is now it seems to group together your towers so you can see the total fuel required per hour. That is great! You can type in what you have in the outpost and see how many days and hours left. The downside I see is that you have made this outpost track to calculate the 'Online' time from when the outpost was last updated. As if my towers are using the fuel in the outpost, and not their own fuel.
My situation, which I believe alot of us have, is that I have a bunch of towers that I need to fuel. I take fuel from the outpost and fuel the towers. After all towers are fueled I type in the new fuel levels that are left in the outpost so I easily can see what we are low on, and how long we will last on it next time I fuel.
I dont really understand why the outpost track calculates fuel levels from when it was last updated.
|
Elana Vaho
|
Posted - 2009.03.12 11:04:00 -
[8]
Originally by: Johnathan Roark
Originally by: Elana Vaho
Exactly why do you want to use the Outpost Track page? As it is now it seems to group together your towers so you can see the total fuel required per hour. That is great! You can type in what you have in the outpost and see how many days and hours left. The downside I see is that you have made this outpost track to calculate the 'Online' time from when the outpost was last updated. As if my towers are using the fuel in the outpost, and not their own fuel.
My situation, which I believe alot of us have, is that I have a bunch of towers that I need to fuel. I take fuel from the outpost and fuel the towers. After all towers are fueled I type in the new fuel levels that are left in the outpost so I easily can see what we are low on, and how long we will last on it next time I fuel.
I dont really understand why the outpost track calculates fuel levels from when it was last updated.
This is now fixed in the svn or at least it should be.
Sounds great! I'm updating my version now and see how it goes.
On another note, I added the new alchemy reactions and the unrefined materials to my database with their current IDs from EVE and it works brilliantly. I exported the two tables where I added the new materials and the reactions.
material_static
reaction_static
|
Elana Vaho
|
Posted - 2009.03.12 23:36:00 -
[9]
Edited by: Elana Vaho on 12/03/2009 23:37:07
Originally by: Johnathan Roark
Originally by: Elana Vaho
The amount of LO and HW per hour on the Outpost Track still shows way off. 15 million LO and 11k HW for 6 towers. LO should be 397 per hour, and the "online" timer shows 2D 23H left. When I run the numbers myself that online timer burns LO at a rate of 3430 per hour. Same goes with HW. The other numbers are perfect.
For Outposts that are not tracking any towers at all everything shows as 0, except for LO and HW where this field is blank.
This is now fixed as well in SVN, it was displaying the pg and cpu and not the heavy water and ozone.
The numbers have changed, but they are still wrong.
Liquid Ozone .|. 3385(411) .|. 243578 .|. 2d 23h
Heavy Water .|. 1374(411) .|. 609748 .|. 18d 11h
The numbers seems to be the same as the "Online" timer now, but they are not the 397 LO and 193 HW as they should be when I add them by hand.
|
Elana Vaho
|
Posted - 2009.03.13 14:15:00 -
[10]
Originally by: Doc Punkiller
for some reason (beta 5) i had to make the following modification in production.php in order to have the correct amount and volumes displayed :
line 295, change :
$silo[$x]['material_amount'] = ($rate_vol*$silo[$x]['hoursago'])+$silo[$x]['material_amount'];///$mat info['material_volume']+$silo[$x]['material_amount'];
by
$silo[$x]['material_amount'] = ($silo[$x]['rate']*$silo[$x]['hoursago'])+$silo[$x]['material_amount'];/ //$matinfo['material_volume']+$silo[$x]['material_amount'];
This fix is working for me, but has not yet been changed in your SVN.
|
Elana Vaho
|
Posted - 2009.03.14 00:13:00 -
[11]
Yes, the (411) is correct. This is my current pos list for the outpost I'm tracking
Large Minmatar
PG: 4,237,500 / 4,375,000 LO: 110 (113)
CPU: 1200 / 6000 HW: 23 (113)
Large Minmatar
PG: 4,337,500 / 4,375,000 LO: 113 (113)
CPU: 1350 / 6000 HW: 26 (113)
Small Minmatar
PG: 952,500 / 1,093,750 LO: 26 (29)
CPU: 1075 / 1500 HW: 21 (29)
Medium Amarr
PG: 2,442,500 / 2,500,000 LO: 56 (57)
CPU: 1500 / 2750 HW: 32 (57)
Medium Gallente
PG: 1,735,000 / 1,875,000 LO: 53 (57)
CPU: 3075 / 3375 HW: 52 (57)
Medium Shadow
PG: 1,735,000 / 1,875,000 LO: 39 (42)
CPU: 3075 / 3375 HW: 39 (42)
TOTAL
======
PG: 15,440,000 / 16,093,750
CPU: 11,275 / 23,000
Calculations by hand
=====================
LO: 397 (411)
HW: 193 (411)
Calculations according to your method
======================================
LO: (15,440,000 / 16,093,750) * 411 = 394
HW: (11,275 / 23,000) * 411 = 201
|
Elana Vaho
|
Posted - 2009.03.14 12:41:00 -
[12]
Found some typos on class.pos.php which made the online timer for Oxygen isopotes to show as 0 on the Outpost Track page. For some reason your variable for total required oxygen isotopes is misspelled everywhere as oyxgen, except for the 2 places I found that corrected the online timer.
Row 5317:
$calc_oxygen_iso = (floor($current_oxygen_iso / $total_req_oxygen_iso));
Change to:
$calc_oxygen_iso = (floor($current_oxygen_iso / $total_req_oyxgen_iso));
Row 5370:
if($total_oxygen_req__iso>0) {
Change to:
if($total_req_oyxgen_iso>0) {
I'm still trying to track down the LO and HW bug on the same page.
|
Elana Vaho
|
Posted - 2009.03.14 12:58:00 -
[13]
I found the LO and HW bug on Outpost Track page.
Your idea is to calculate (total_current_pg / total_pg) * total_req_ozone
The problem with this is that the variable total_pg is not the actual total PG from all towers. Instead it's the total PG from the last tower in the loop.
In my situation with 6 towers the calculation was like this:
(15,440,000 / 2,500,000) * 411 = 2538
As you can see the total_current_pg is correct as you calculate this every time in your loop from every tower, but the other total_pg variable you are not, and is the variable you use for each tower instead of adding them together. 2,500,000 PG is from my medium amarr tower which was last in the loop.
By simply adding a new total variable where you add the towers max PG and CPU, change the two calculations I get it to work now. Even if they are a tiny bit off the real numbers when I add it by hand its not that much.
|
Elana Vaho
|
Posted - 2009.03.28 22:38:00 -
[14]
Originally by: Dan Brimstone
Originally by: Dan Brimstone
Ok so I found a problem with the Titanium Carbide reaction. Instead of showing the number of units in the silo it is displaying the m3 in that column. So instead of 20k units and 1,000m3 it is currently displaying 1k units and 50 m3. Which is throwing off the calculations for the time till the silo is full. Can anyone help me try and fix this?
Bump to my question earlier. Anyone have a solution?
I have had the same problem. This however solved it for me.
Originally by: Doc Punkillerfor
some reason (beta 5) i had to make the following modification in production.php in order to have the correct amount and volumes displayed :
line 295, change :
$silo[$x]['material_amount'] = ($rate_vol*$silo[$x]['hoursago'])+$silo[$x]['material_amount'];///$matinfo['material_volume']+$silo[$x]['material_amount'];
by
$silo[$x]['material_amount'] = ($silo[$x]['rate']*$silo[$x]['hoursago'])+$silo[$x]['material_amount'];///$matinfo['material_volume']+$silo[$x]['material_amount'];
|
Elana Vaho
|
Posted - 2009.05.20 17:18:00 -
[15]
Having problems with fuel levels on our towers in a sov4 system. After doing some manual calculations it seems that these towers are only getting 25% fuel bonus, like the ordinary sov3 systems do. Anyone else have any problems with this? I thought sov4 gave 30% bonus but apparently CCP fails :(
|
Elana Vaho
|
Posted - 2009.05.20 20:26:00 -
[16]
Yes sorry, thats what I meant. The postracker is working perfectly, its the towers in EVE that is getting the wrong bonuses (25% in sov4).
|
Elana Vaho
|
Posted - 2009.06.02 17:54:00 -
[17]
Getting some small rounding errors on LO and HW. When viewing the tower in postracker it shows for the most times one extra LO or HW per hour then what the tower actually uses in EVE. Like 26 LO in the postracker, but 25 in EVE. I havent yet seen the opposite, postracker showing less per hour, its always 1 higher or spot on.
|
Elana Vaho
|
Posted - 2009.12.10 19:24:00 -
[18]
Any news when a patch will get out so we can get sov bonuses back? Atm its a pain to refuel towers as they are still getting bonus from sov, but not in postracker. Postracker shows sov lvl 0, but sov is friendly.
|
Elana Vaho
|
Posted - 2009.12.12 15:48:00 -
[19]
If you need help with testing let me know ;)
|
| |
|